package com.mysteel.cyx.demo.baomidou.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mysteel.cyx.demo.baomidou.entity.Department;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author：cyx
 * @Date：2024/5/8 14:18
 */
public interface DepartmentMapper extends BaseMapper<Department> {

    List<Department> getNodeTreeByDepartmentId(@Param("departmentId") Long departmentId);
    List<Department> getNodeTreeByDepartmentId1(@Param("departmentId") Long departmentId);

    /**
     * mysql 8.0之后的函数
     * @param departmentId
     * @return
     */
    List<Department> getNodeTreeByDepartmentId2(@Param("departmentId") Long departmentId);


}
